package com.tmindtech.api.enterprise.db

import com.tmindtech.api.enterprise.model.Enterprise
import org.apache.ibatis.annotations.Select
import tk.mybatis.mapper.common.Mapper

/**
 * Created by RexQian on 2017/11/22.
 */
interface EnterpriseMapper : Mapper<Enterprise> {
    @Select("SELECT category FROM t_enterprise GROUP BY category")
    fun selectCategorys(): List<String>

    @Select("SELECT * FROM t_enterprise WHERE category is NOT NULL")
    fun selectAllEnterprise(): List<Enterprise>
}
